SET identity_insert [dbo].[Incidents]  ON

INSERT 
[dbo].[Incidents] 
([DepartmentType], [Id], [CityId], [CallNumber], [Phone], [UnmaskedPhone], [Title], 
[ReceivedTime], [Address], [ReportingParty], [UnmaskedReportingParty], 
[Description], [UpdateDescription], [Longitude], [Latitude], 
[IsHighPriority], [IncidentCategory], [SearchAreaId]) 
SELECT 1, 263, 24, N'201-4388', N'(312) 850-3331', N'(312) 850-3331', N'Public Disturbance', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'4722 W Augusta Blvd, Chicago, IL 60651', N'Darren XXXXX', N'Darren Parker', N'Reports of a domestic disturbance reported by park maintenance.', N'', -87.7444, 41.89908, 0, 4, NULL UNION ALL
SELECT 1, 264, 24, N'201-4389', N'(312) 565-1547', N'(312) 565-1547', N'Stranger reported near school', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'7055 W North Ave, IL 60707', N'Terrence XXXXX', N'Terrence Philip', N'A man acting strangely reported near Inglewood Middle School', N'', -87.80384, 41.90884, 0, 7, NULL UNION ALL
SELECT 1, 271, 24, N'201-4390', N'(312) 467-5442', N'(312) 467-5442', N'Speeding', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'3136 S Green St, Chicago, IL 60608', N'Andrew XXXXX', N'Andrew Lan', N'Speeding vehicle', N'Speeding vehicle. Driver has collided with the curb. In shock and potentially sustained an injury.', -87.64729, 41.83612, 1, 4, NULL UNION ALL
SELECT 1, 278, 24, N'201-4390', N'(555) 230-6031', N'(555) 230-6031', N'Car broken down in middle of road', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'Refectory Dr, Chicago, IL 60622', N'Bruno XXXXX', N'Bruno Torres', N'A car is immobile and blocking traffic', N'', -87.70384, 41.90762, 0, 4, NULL UNION ALL
SELECT 1, 276, 24, N'201-4390', N'(555) 610-4506', N'(555) 610-4506', N'Car crash', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'812 S Scoville Ave, Oak Park, IL 60304', N'Darya XXXXX', N'Darya Popkova', N'Car crash, no serious injuries reported, accident is blocking both lanes', N'', -87.78769, 41.87388, 0, 4, NULL UNION ALL
SELECT 1, 272, 24, N'201-4390', N'(312) 820-5051', N'(312) 820-5051', N'Car break in', CAST(N'2017-01-26T12:21:58.770' AS DateTime), N'1709 S State St, Chicago, IL 60616', N'Oliver XXXXX', N'Oliver Lee', N'Report of an individual wearing an orange hooded jacket breaking into a car', N'', -87.6267, 41.85891, 0, 6, NULL UNION ALL
SELECT 1, 291, 25, N'201-4388', N'(11) 177-8915', N'(11) 177-8915', N'Public Disturbance', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'44 Mount Ida Rd, Johannesburg, 2091, South Africa', N'Darren XXXXX', N'Darren Parker', N'Reports of a domestic disturbance reported by park maintenance.', N'', 28.01967, -26.24487, 0, 4, NULL UNION ALL
SELECT 1, 292, 25, N'201-4389', N'(11) 874-0952', N'(11) 874-0952', N'Stranger reported near school', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'Johannesburg, Gauteng, South Africa', N'Terrence XXXXX', N'Terrence Philip', N'A man acting strangely reported near Inglewood Middle School', N'', 28.09636, -26.22413, 0, 7, NULL UNION ALL
SELECT 1, 299, 25, N'201-4390', N'(11) 118-0632', N'(11) 118-0632', N'Speeding', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'50 De Villiers St, Johannesburg, 2190, South Africa', N'Andrew XXXXX', N'Andrew Lan', N'Speeding vehicle', N'Speeding vehicle. Driver has collided with the curb. In shock and potentially sustained an injury.', 28.03709, -26.24322, 1, 4, NULL UNION ALL
SELECT 1, 300, 25, N'201-4390', N'(11) 686-7118', N'(11) 686-7118', N'Car break in', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'2001, Gauteng, South Africa', N'Oliver XXXXX', N'Oliver Lee', N'Report of an individual wearing an orange hooded jacket breaking into a car', N'', 27.97322, -26.22559, 0, 6, NULL UNION ALL
SELECT 1, 304, 25, N'201-4390', N'(555) 610-4506', N'(555) 610-4506', N'Car crash', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'56A Greenhill Rd, Johannesburg, 2193, South Africa', N'Darya XXXXX', N'Darya Popkova', N'Car crash, no serious injuries reported, accident is blocking both lanes', N'', 28.01538, -26.16127, 0, 4, NULL UNION ALL
SELECT 1, 306, 25, N'201-4390', N'(555) 230-6031', N'(555) 230-6031', N'Car broken down in middle of road', CAST(N'2017-01-26T12:22:01.720' AS DateTime), N'Francois Oberholzer, Johannesburg, 2011, South Africa', N'Bruno XXXXX', N'Bruno Torres', N'A car is immobile and blocking traffic', N'', 28.10383, -26.21196, 0, 4, NULL UNION ALL
SELECT 1, 319, 26, N'201-4388', N'(69) 866-224', N'(69) 866-224', N'Public Disturbance', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Gutleutstraße 138, 60327 Frankfurt', N'Darren XXXXX', N'Darren Parker', N'Reports of a domestic disturbance reported by park maintenance.', N'', 8.66133, 50.10318, 0, 4, NULL UNION ALL
SELECT 1, 320, 26, N'201-4389', N'(69) 589-350', N'(69) 589-350', N'Stranger reported near school', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Altenhainer Straße, 60327 Frankfurt', N'Terrence XXXXX', N'Terrence Philip', N'A man acting strangely reported near Inglewood Middle School', N'', 8.63246, 50.10646, 0, 7, NULL UNION ALL
SELECT 1, 327, 26, N'201-4390', N'(69) 877-220', N'(69) 877-220', N'Speeding', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Deutschordenstraße, 60528 Frankfurt', N'Andrew XXXXX', N'Andrew Lan', N'Speeding vehicle', N'Speeding vehicle. Driver has collided with the curb. In shock and potentially sustained an injury.', 8.65142, 50.09121, 1, 4, NULL UNION ALL
SELECT 1, 332, 26, N'201-4390', N'(555) 610-4506', N'(555) 610-4506', N'Car crash', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Zeppelinallee, 60325 Frankfurt', N'Darya XXXXX', N'Darya Popkova', N'Car crash, no serious injuries reported, accident is blocking both lanes', N'', 8.65419, 50.12123, 0, 4, NULL UNION ALL
SELECT 1, 334, 26, N'201-4390', N'(555) 230-6031', N'(555) 230-6031', N'Car broken down in middle of road', CAST(N'2017-01-26T12:22:04.563' AS DateTime), N'Hanauer Landstraße 36, 60314 Frankfurt', N'Bruno XXXXX', N'Bruno Torres', N'A car is immobile and blocking traffic', N'', 8.69967, 50.11289, 0, 4, NULL UNION ALL
SELECT 1, 347, 27, N'201-4388', N'(202) 153-8340', N'(202) 153-8340', N'Public Disturbance', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'Street, Arlington, VA 22205', N'Darren XXXXX', N'Darren Parker', N'Reports of a domestic disturbance reported by park maintenance.', N'', -77.13479, 38.88408, 0, 4, NULL UNION ALL
SELECT 1, 348, 27, N'201-4389', N'(202) 972-1394', N'(202) 972-1394', N'Stranger reported near school', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'1909 MacArthur Dr, McLean, VA 22101', N'Terrence XXXXX', N'Terrence Philip', N'A man acting strangely reported near Inglewood Middle School', N'', -77.16, 38.91296, 0, 7, NULL UNION ALL
SELECT 1, 355, 27, N'201-4390', N'(202) 245-9308', N'(202) 245-9308', N'Speeding', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'616 Kensington Pl NE, Washington, DC 20011', N'Andrew XXXXX', N'Andrew Lan', N'Speeding vehicle', N'Speeding vehicle. Driver has collided with the curb. In shock and potentially sustained an injury.', -76.99763, 38.95801, 1, 4, NULL UNION ALL
SELECT 1, 356, 27, N'201-4390', N'(202) 410-7527', N'(202) 410-7527', N'Car break in', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'5241 Newton St, Bladensburg, MD 20710', N'Oliver XXXXX', N'Oliver Lee', N'Report of an individual wearing an orange hooded jacket breaking into a car', N'', -76.92816, 38.93551, 0, 6, NULL UNION ALL
SELECT 1, 360, 27, N'201-4390', N'(555) 610-4506', N'(555) 610-4506', N'Car crash', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'494 Xenia Ave, Capitol Heights, MD 20743', N'Darya XXXXX', N'Darya Popkova', N'Car crash, no serious injuries reported, accident is blocking both lanes', N'', -76.9047, 38.8849, 0, 4, NULL UNION ALL
SELECT 1, 362, 27, N'201-4390', N'(555) 230-6031', N'(555) 230-6031', N'Car broken down in middle of road', CAST(N'2017-01-26T12:22:07.290' AS DateTime), N'4637 24th St N, Arlington, VA 22207', N'Bruno XXXXX', N'Bruno Torres', N'A car is immobile and blocking traffic', N'', -77.12311, 38.9017, 0, 4, NULL UNION ALL
SELECT 1, 375, 28, N'201-4388', N'9122-2793', N'9122-2793', N'Public Disturbance', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'200 Ang Mo Kio Ave 9, Singapore 569770, Singapore', N'Darren XXXXX', N'Darren Parker', N'Reports of a domestic disturbance reported by park maintenance.', N'', 103.84551, 1.3825, 0, 4, NULL UNION ALL
SELECT 1, 376, 28, N'201-4389', N'849-7993', N'849-7993', N'Stranger reported near school', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'3 Swiss Cottage Este, Singapore 307521, Singapore', N'Terrence XXXXX', N'Terrence Philip', N'A man acting strangely reported near Inglewood Middle School', N'', 103.8308, 1.32103, 0, 7, NULL UNION ALL
SELECT 1, 383, 28, N'201-4390', N'129-3880', N'129-3880', N'Speeding', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Singapore', N'Andrew XXXXX', N'Andrew Lan', N'Speeding vehicle', N'Speeding vehicle. Driver has collided with the curb. In shock and potentially sustained an injury.', 104.05782, 1.39317, 1, 4, NULL UNION ALL
SELECT 1, 384, 28, N'201-4390', N'464-1655', N'464-1655', N'Car break in', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'450C Tampines St 42, Singapore 523450, Singapore', N'Oliver XXXXX', N'Oliver Lee', N'Report of an individual wearing an orange hooded jacket breaking into a car', N'', 103.95207, 1.3573, 0, 6, NULL UNION ALL
SELECT 1, 388, 28, N'201-4390', N'(555) 610-4506', N'(555) 610-4506', N'Car crash', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Kampung Lepau, 81600 Pengerang, Johore, Malaysia', N'Darya XXXXX', N'Darya Popkova', N'Car crash, no serious injuries reported, accident is blocking both lanes', N'', 104.14582, 1.36753, 0, 4, NULL UNION ALL
SELECT 1, 390, 28, N'201-4390', N'(555) 230-6031', N'(555) 230-6031', N'Car broken down in middle of road', CAST(N'2017-01-26T12:22:10.253' AS DateTime), N'Singapore, Singapore', N'Bruno XXXXX', N'Bruno Torres', N'A car is immobile and blocking traffic', N'', 103.89021, 1.31769, 0, 4, NULL UNION ALL
SELECT 1, 411, 29, N'201-4390', N'(80) 0544-8722', N'(80) 0544-8722', N'Speeding', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'386 1st A Main Road, 1st Phase, Girinagar, Bengaluru 560026, India', N'Andrew XXXXX', N'Andrew Lan', N'Speeding vehicle', N'Speeding vehicle. Driver has collided with the curb. In shock and potentially sustained an injury.', 77.54595, 12.94016, 1, 4, NULL UNION ALL
SELECT 1, 412, 29, N'201-4390', N'(80) 0609-3878', N'(80) 0609-3878', N'Car break in', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'109 1st Cross Road, Ittamadu, Bengaluru 560085, India', N'Oliver XXXXX', N'Oliver Lee', N'Report of an individual wearing an orange hooded jacket breaking into a car', N'', 77.54974, 12.92091, 0, 6, NULL UNION ALL
SELECT 1, 416, 29, N'201-4390', N'(555) 610-4506', N'(555) 610-4506', N'Car crash', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'Domlur, Bengaluru 560007, India', N'Darya XXXXX', N'Darya Popkova', N'Car crash, no serious injuries reported, accident is blocking both lanes', N'', 77.63253, 12.96058, 0, 4, NULL UNION ALL
SELECT 1, 418, 29, N'201-4390', N'(555) 230-6031', N'(555) 230-6031', N'Car broken down in middle of road', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'Gandhi Nagar, Bengaluru 560009, India', N'Bruno XXXXX', N'Bruno Torres', N'A car is immobile and blocking traffic', N'', 77.57221, 12.98118, 0, 4, NULL UNION ALL
SELECT 1, 446, 30, N'201-4390', N'(555) 230-6031', N'(555) 230-6031', N'Car broken down in middle of road', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Street, 26027 Rivolta d''Adda CR', N'Bruno XXXXX', N'Bruno Torres', N'A car is immobile and blocking traffic', N'', 9.53974, 45.46388, 0, 4, NULL UNION ALL
SELECT 1, 431, 30, N'201-4388', N'(911) 2867-490', N'(911) 2867-4906', N'Public Disturbance', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Via Campazzino, 20141 Milan MI', N'Darren XXXXX', N'Darren Parker', N'Reports of a domestic disturbance reported by park maintenance.', N'', 9.18691, 45.42522, 0, 4, NULL UNION ALL
SELECT 1, 432, 30, N'201-4389', N'(911) 263-4105', N'(911) 263-4105', N'Stranger reported near school', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Rivolta d''Adda, Lomb., Italy', N'Terrence XXXXX', N'Terrence Philip', N'A man acting strangely reported near Inglewood Middle School', N'', 9.53415, 45.46986, 0, 7, NULL UNION ALL
SELECT 1, 439, 30, N'201-4390', N'(911) 8881-7854', N'(911) 8881-7854', N'Speeding', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Via Giotto & Via Oriani, 20060 Mediglia MI', N'Andrew XXXXX', N'Andrew Lan', N'Speeding vehicle', N'Speeding vehicle. Driver has collided with the curb. In shock and potentially sustained an injury.', 9.36018, 45.42601, 1, 4, NULL UNION ALL
SELECT 1, 440, 30, N'201-4390', N'(911) 8006-4640', N'(911) 8006-4640', N'Car break in', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Truccazzano, Lomb., Italy', N'Oliver XXXXX', N'Oliver Lee', N'Report of an individual wearing an orange hooded jacket breaking into a car', N'', 9.4841, 45.44971, 0, 6, NULL UNION ALL
SELECT 1, 444, 30, N'201-4390', N'(555) 610-4506X', N'(555) 610-4506', N'Car crash', CAST(N'2017-01-26T12:22:17.247' AS DateTime), N'Via Conte Francesco Annoni, 28069 Trecate NO', N'Darya XXXXX', N'Darya Popkova', N'Car crash, no serious injuries reported, accident is blocking both lanes', N'', 8.75464, 45.43131, 0, 4, NULL UNION ALL
SELECT 1, 459, 31, N'201-4388', N'(85) 739-2776', N'(85) 739-2776', N'Public Disturbance', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Knooppunt Holendrecht, 1105 Amsterdam, Netherlands', N'Darren XXXXX', N'Darren Parker', N'Reports of a domestic disturbance reported by park maintenance.', N'', 4.94271, 52.29456, 0, 4, NULL UNION ALL
SELECT 1, 460, 31, N'201-4389', N'(85) 865-8730', N'(85) 865-8730', N'Stranger reported near school', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Ringdijk Boven Polder 6, 1186 WB Amstelveen, Netherlands', N'Terrence XXXXX', N'Terrence Philip', N'A man acting strangely reported near Inglewood Middle School', N'', 4.8768, 52.27472, 0, 7, NULL UNION ALL
SELECT 1, 472, 31, N'201-4390', N'(555) 610-4506', N'(555) 610-4506', N'Car crash', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Tenderstraat 1, 1019 TT Amsterdam, Netherlands', N'Darya XXXXX', N'Darya Popkova', N'Car crash, no serious injuries reported, accident is blocking both lanes', N'', 4.94006, 52.37269, 0, 4, NULL UNION ALL
SELECT 1, 474, 31, N'201-4390', N'(555) 230-6031', N'(555) 230-6031', N'Car broken down in middle of road', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Amsteldijk Noord, 1183 TK Amstelveen, Netherlands', N'Bruno XXXXX', N'Bruno Torres', N'A car is immobile and blocking traffic', N'', 4.89794, 52.31958, 0, 4, NULL UNION ALL
SELECT 1, 468, 31, N'201-4390', N'(85)882-8827', N'(85) 882-8827', N'Car break in', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Klokkenbergweg 3, 1101 AK Amsterdam, Netherlands', N'Oliver XXXXX', N'Oliver Lee', N'Report of an individual wearing an orange hooded jacket breaking into a car', N'', 4.93592, 52.30366, 0, 6, NULL UNION ALL
SELECT 1, 467, 31, N'201-4390', N'(85)403-8151', N'(85) 403-8151', N'Speeding', CAST(N'2017-01-26T12:22:20.700' AS DateTime), N'Dijksgracht 18A, 1019 BS Amsterdam, Netherlands', N'Andrew XXXXX', N'Andrew Lan', N'Speeding vehicle', N'Speeding vehicle. Driver has collided with the curb. In shock and potentially sustained an injury.', 4.9189, 52.37546, 1, 4, NULL UNION ALL
SELECT 1, 487, 32, N'201-4388', N'(871) 242-5939', N'(871) 242-5939', N'Public Disturbance', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'Hodge Hill Common, Birmingham, B36 8', N'Darren XXXXX', N'Darren Parker', N'Reports of a domestic disturbance reported by park maintenance.', N'', -1.80817, 52.49807, 0, 4, NULL UNION ALL
SELECT 1, 488, 32, N'201-4389', N'(871) 703-6578', N'(871) 703-6578', N'Stranger reported near school', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'269 Washwood Heath Road, Washwood Heath, B8 2', N'Terrence XXXXX', N'Terrence Philip', N'A man acting strangely reported near Inglewood Middle School', N'', -1.8494, 52.49607, 0, 7, NULL UNION ALL
SELECT 1, 495, 32, N'201-4390', N'(871) 955-0441', N'(871) 955-0441', N'Speeding', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'109 Tenby Road, Moseley, B13 9', N'Andrew XXXXX', N'Andrew Lan', N'Speeding vehicle', N'Speeding vehicle. Driver has collided with the curb. In shock and potentially sustained an injury.', -1.85656, 52.43933, 1, 4, NULL UNION ALL
SELECT 1, 502, 32, N'201-4390', N'(555) 230-6031', N'(555) 230-6031', N'Car broken down in middle of road', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'13 North Pathway, Harborne, B17 9', N'Bruno XXXXX', N'Bruno Torres', N'A car is immobile and blocking traffic', N'', -1.96042, 52.4639, 0, 4, NULL UNION ALL
SELECT 1, 500, 32, N'201-4390', N'(555) 610-4506', N'(555) 610-4506', N'Car crash', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'196 Waterloo Road, Yardley, B25 8', N'Darya XXXXX', N'Darya Popkova', N'Car crash, no serious injuries reported, accident is blocking both lanes', N'', -1.82535, 52.46129, 0, 4, NULL UNION ALL
SELECT 1, 496, 32, N'201-4390', N'(871) 42-6498', N'(871) 42-6498', N'Car break in', CAST(N'2017-01-26T12:22:24.160' AS DateTime), N'Aston Webb Boulevard, Selly Oak, B29 6', N'Oliver XXXXX', N'Oliver Lee', N'Report of an individual wearing an orange hooded jacket breaking into a car', N'', -1.94116, 52.44644, 0, 6, NULL UNION ALL
SELECT 1, 515, 33, N'201-4388', N'(78) 878-098', N'(78) 878-098', N'Public Disturbance', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Slotsherrensvej, 2610 Rødovre, Denmark', N'Darren XXXXX', N'Darren Parker', N'Reports of a domestic disturbance reported by park maintenance.', N'', 12.43803, 55.7041, 0, 4, NULL UNION ALL
SELECT 1, 516, 33, N'201-4389', N'(78) 693-921', N'(78) 693-921', N'Stranger reported near school', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'2770 Kastrup, Denmark', N'Terrence XXXXX', N'Terrence Philip', N'A man acting strangely reported near Inglewood Middle School', N'', 12.51155, 55.61582, 0, 7, NULL UNION ALL
SELECT 1, 403, 29, N'201-4388', N'(80) 0170-7488', N'(80) 0170-7488', N'Public Disturbance', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'3rd Main Road, Sharavathi Nagar, Pattegar Palya, Bengaluru 560072, India', N'Darren XXXXX', N'Darren Parker', N'Reports of a domestic disturbance reported by park maintenance.', N'', 77.52166, 12.97762, 0, 4, NULL UNION ALL
SELECT 1, 404, 29, N'201-4389', N'(80) 0851-4071', N'(80) 0851-4071', N'Stranger reported near school', CAST(N'2017-01-26T12:22:13.963' AS DateTime), N'48 5th Main Road, Anjaneya Nagar, Ittamadu, Bengaluru 560085, India', N'Terrence XXXXX', N'Terrence Philip', N'A man acting strangely reported near Inglewood Middle School', N'', 77.54413, 12.92793, 0, 7, NULL UNION ALL
SELECT 1, 523, 33, N'201-4390', N'(78) 496-561', N'(78) 496-561', N'Speeding', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Tavlestien 2, 2605 Brøndby, Denmark', N'Andrew XXXXX', N'Andrew Lan', N'Speeding vehicle', N'Speeding vehicle. Driver has collided with the curb. In shock and potentially sustained an injury.', 12.41975, 55.63993, 1, 4, NULL UNION ALL
SELECT 1, 524, 33, N'201-4390', N'(78) 778-572', N'(78) 778-572', N'Car break in', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Grønttorvet, 2500 Copenhagen, Denmark', N'Oliver XXXXX', N'Oliver Lee', N'Report of an individual wearing an orange hooded jacket breaking into a car', N'', 12.50234, 55.65604, 0, 6, NULL UNION ALL
SELECT 1, 528, 33, N'201-4390', N'(555) 610-4506', N'(555) 610-4506', N'Car crash', CAST(N'2017-01-26T12:22:27.447' AS DateTime), N'Damhus Boulevard 24, 2610 Rødovre, Denmark', N'Darya XXXXX', N'Darya Popkova', N'Car crash, no serious injuries reported, accident is blocking both lanes', N'', 12.46983, 55.67075, 0, 4, NULL UNION ALL
SELECT 1, 543, 34, N'201-4388', N'(2) 9099-0152', N'(2) 9099-0152', N'Public Disturbance', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Jongno-gu Hongji-dong 68-5', N'Darren XXXXX', N'Darren Parker', N'Reports of a domestic disturbance reported by park maintenance.', N'', 126.95695, 37.60229, 0, 4, NULL UNION ALL
SELECT 1, 544, 34, N'201-4389', N'(2) 525-5385', N'(2) 525-5385', N'Stranger reported near school', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Seodaemun-gu Namgajwa-dong 291-57', N'Terrence XXXXX', N'Terrence Philip', N'A man acting strangely reported near Inglewood Middle School', N'', 126.91585, 37.56871, 0, 7, NULL UNION ALL
SELECT 1, 551, 34, N'201-4390', N'(2) 9452-6294', N'(2) 9452-6294', N'Speeding', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Yongsan-gu Bogwang-dong 222-1', N'Andrew XXXXX', N'Andrew Lan', N'Speeding vehicle', N'Speeding vehicle. Driver has collided with the curb. In shock and potentially sustained an injury.', 127.00001, 37.52709, 1, 4, NULL UNION ALL
SELECT 1, 552, 34, N'201-4390', N'(2) 7735-614', N'(2) 7735-6145', N'Car break in', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Mapo-gu Gongdeok-dong 190-4', N'Oliver XXXXX', N'Oliver Lee', N'Report of an individual wearing an orange hooded jacket breaking into a car', N'', 126.95044, 37.54921, 0, 6, NULL UNION ALL
SELECT 1, 556, 34, N'201-4390', N'(555) 610-4506', N'(555) 610-4506', N'Car crash', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Yongsan-gu Ichon-dong 381-1', N'Darya XXXXX', N'Darya Popkova', N'Car crash, no serious injuries reported, accident is blocking both lanes', N'', 126.95734, 37.52165, 0, 4, NULL UNION ALL
SELECT 1, 558, 34, N'201-4390', N'(555) 230-6031', N'(555) 230-6031', N'Car broken down in middle of road', CAST(N'2017-01-26T12:22:31.140' AS DateTime), N'Seoul Mapo-gu Seogyo-dong 405-8', N'Bruno XXXXX', N'Bruno Torres', N'A car is immobile and blocking traffic', N'', 126.92038, 37.55047, 0, 4, NULL UNION ALL
SELECT 1, 571, 35, N'201-4388', N'(555) 685-5267', N'(555) 685-5267', N'Public Disturbance', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'Beaver Lake Park, 25101 SE 24th St, Sammamish, WA 98075', N'Darren XXXXX', N'Darren Parker', N'Reports of a domestic disturbance reported by park maintenance.', N'', -122.004659, 47.587853, 0, 4, NULL UNION ALL
SELECT 1, 572, 35, N'201-4389', N'(555) 401-3768', N'(555) 401-3768', N'Stranger reported near school', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'24072 NE 8th St, Sammamish, WA 98074', N'Terrence XXXXX', N'Terrence Philip', N'A man acting strangely reported near Inglewood Middle School', N'', -122.018394, 47.61672, 0, 7, NULL UNION ALL
SELECT 1, 579, 35, N'201-4390', N'(555) 327-3730', N'(555) 327-3730', N'Speeding', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'24442 SE 32nd St, WA 98075', N'Andrew XXXXX', N'Andrew Lan', N'Speeding vehicle', N'Speeding vehicle. Driver has collided with the curb. In shock and potentially sustained an injury.', -122.01355, 47.58073, 1, 4, NULL UNION ALL
SELECT 1, 580, 35, N'201-4390', N'(555) 962-7669', N'(555) 962-7669', N'Car break in', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'383 220th Pl SE, Sammamish, WA 98074', N'Oliver XXXXX', N'Oliver Lee', N'Report of an individual wearing an orange hooded jacket breaking into a car', N'', -122.04491, 47.60554, 0, 6, NULL UNION ALL
SELECT 1, 586, 35, N'201-4390', N'(555) 230-6031', N'(555) 230-6031', N'Car broken down in middle of road', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'2368 205th Ave SE, Sammamish, WA 98075', N'Bruno XXXXX', N'Bruno Torres', N'A car is immobile and blocking traffic', N'', -122.06611, 47.58856, 0, 4, NULL UNION ALL
SELECT 1, 584, 35, N'201-4390', N'(555) 610-4506', N'(555) 610-4506', N'Car crash', CAST(N'2017-01-26T12:24:38.720' AS DateTime), N'26666 NE Ames Lake Rd, Redmond, WA 98053', N'Darya XXXXX', N'Darya Popkova', N'Car crash, no serious injuries reported, accident is blocking both lanes', N'', -121.984085, 47.633244, 0, 4, NULL
GO